Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 7273 |
| Missing cells | 5667 |
| Missing cells (%) | 6.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 738.8 KiB |
| Average record size in memory | 104.0 B |
Variable types
| Categorical | 2 |
|---|---|
| Numeric | 11 |
Symbol has a high cardinality: 2240 distinct values | High cardinality |
ESG Score is highly correlated with Environmental Pillar Score and 2 other fields | High correlation |
Environmental Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
Social Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
Governance Pillar Score is highly correlated with ESG Score | High correlation |
semi-variance (down) is highly correlated with VaR (95%) | High correlation |
VaR (95%) is highly correlated with semi-variance (down) | High correlation |
ESG Score is highly correlated with Environmental Pillar Score and 2 other fields | High correlation |
Environmental Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
Social Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
Governance Pillar Score is highly correlated with ESG Score | High correlation |
semi-variance (down) is highly correlated with VaR (95%) | High correlation |
VaR (95%) is highly correlated with semi-variance (down) | High correlation |
ESG Score is highly correlated with Environmental Pillar Score and 1 other fields | High correlation |
Environmental Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
Social Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
semi-variance (down) is highly correlated with VaR (95%) | High correlation |
VaR (95%) is highly correlated with semi-variance (down) | High correlation |
ESG Score is highly correlated with Environmental Pillar Score and 2 other fields | High correlation |
Environmental Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
Social Pillar Score is highly correlated with ESG Score and 1 other fields | High correlation |
Governance Pillar Score is highly correlated with ESG Score | High correlation |
mean-return is highly correlated with VaR (95%) | High correlation |
semi-variance (down) is highly correlated with VaR (95%) | High correlation |
kurtosis is highly correlated with skew | High correlation |
skew is highly correlated with kurtosis | High correlation |
VaR (95%) is highly correlated with mean-return and 1 other fields | High correlation |
D(ESG, kurtosis) has 4336 (59.6%) missing values | Missing |
D(ESG, VaR) has 1331 (18.3%) missing values | Missing |
semi-variance (down) is highly skewed (γ1 = 43.67768601) | Skewed |
Symbol is uniformly distributed | Uniform |
ESG Score has unique values | Unique |
semi-variance (down) has unique values | Unique |
kurtosis has unique values | Unique |
skew has unique values | Unique |
Reproduction
| Analysis started | 2022-09-29 03:27:04.743651 |
|---|---|
| Analysis finished | 2022-09-29 03:27:17.590226 |
| Duration | 12.85 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 2240 |
|---|---|
| Distinct (%) | 30.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.9 KiB |
| KINS.OQ | 5 |
|---|---|
| HWKN.OQ | 5 |
| HOFT.OQ | 5 |
| HOLX.OQ | 5 |
| HOUS.N | 5 |
| Other values (2235) |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 5.834593703 |
| Min length | 3 |
Characters and Unicode
| Total characters | 42435 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 409 ? |
|---|---|
| Unique (%) | 5.6% |
Sample
| 1st row | 360.AX |
|---|---|
| 2nd row | 360.AX |
| 3rd row | A.N |
| 4th row | A.N |
| 5th row | A.N |
Common Values
| Value | Count | Frequency (%) |
| KINS.OQ | 5 | 0.1% |
| HWKN.OQ | 5 | 0.1% |
| HOFT.OQ | 5 | 0.1% |
| HOLX.OQ | 5 | 0.1% |
| HOUS.N | 5 | 0.1% |
| HP.N | 5 | 0.1% |
| HPP.N | 5 | 0.1% |
| HPQ.N | 5 | 0.1% |
| HRI.N | 5 | 0.1% |
| HRTG.N | 5 | 0.1% |
| Other values (2230) | 7223 |
Length
| Value | Count | Frequency (%) |
| kins.oq | 5 | 0.1% |
| mei.n | 5 | 0.1% |
| met.n | 5 | 0.1% |
| meta.oq | 5 | 0.1% |
| mgm.n | 5 | 0.1% |
| mgpi.oq | 5 | 0.1% |
| mhh.a | 5 | 0.1% |
| mho.n | 5 | 0.1% |
| mkc.n | 5 | 0.1% |
| mlab.oq | 5 | 0.1% |
| Other values (2230) | 7223 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 7273 | |
| N | 5470 | |
| O | 3982 | 9.4% |
| Q | 3090 | 7.3% |
| C | 1907 | 4.5% |
| A | 1814 | 4.3% |
| S | 1654 | 3.9% |
| T | 1583 | 3.7% |
| R | 1569 | 3.7% |
| M | 1247 | 2.9% |
| Other values (25) | 12846 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 35120 | |
| Other Punctuation | 7273 | 17.1% |
| Lowercase Letter | 33 | 0.1% |
| Decimal Number | 6 | < 0.1% |
| Connector Punctuation | 3 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 5470 | |
| O | 3982 | 11.3% |
| Q | 3090 | 8.8% |
| C | 1907 | 5.4% |
| A | 1814 | 5.2% |
| S | 1654 | 4.7% |
| T | 1583 | 4.5% |
| R | 1569 | 4.5% |
| M | 1247 | 3.6% |
| I | 1244 | 3.5% |
| Other values (16) | 11560 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 20 | |
| b | 9 | |
| p | 3 | 9.1% |
| q | 1 | 3.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 2 | |
| 6 | 2 | |
| 0 | 2 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 7273 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35153 | |
| Common | 7282 | 17.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 5470 | |
| O | 3982 | 11.3% |
| Q | 3090 | 8.8% |
| C | 1907 | 5.4% |
| A | 1814 | 5.2% |
| S | 1654 | 4.7% |
| T | 1583 | 4.5% |
| R | 1569 | 4.5% |
| M | 1247 | 3.5% |
| I | 1244 | 3.5% |
| Other values (20) | 11593 |
Common
| Value | Count | Frequency (%) |
| . | 7273 | |
| _ | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 0 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 42435 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 7273 | |
| N | 5470 | |
| O | 3982 | 9.4% |
| Q | 3090 | 7.3% |
| C | 1907 | 4.5% |
| A | 1814 | 4.3% |
| S | 1654 | 3.9% |
| T | 1583 | 3.7% |
| R | 1569 | 3.7% |
| M | 1247 | 2.9% |
| Other values (25) | 12846 |
Year
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 56.9 KiB |
| 2020.0 | |
|---|---|
| 2019.0 | |
| 2021.0 | |
| 2018.0 | |
| 2017.0 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 43638 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2020.0 |
|---|---|
| 2nd row | 2021.0 |
| 3rd row | 2017.0 |
| 4th row | 2018.0 |
| 5th row | 2019.0 |
Common Values
| Value | Count | Frequency (%) |
| 2020.0 | 1858 | |
| 2019.0 | 1570 | |
| 2021.0 | 1558 | |
| 2018.0 | 1244 | |
| 2017.0 | 1043 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2020.0 | 1858 | |
| 2019.0 | 1570 | |
| 2021.0 | 1558 | |
| 2018.0 | 1244 | |
| 2017.0 | 1043 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 16404 | |
| 2 | 10689 | |
| . | 7273 | |
| 1 | 5415 | 12.4% |
| 9 | 1570 | 3.6% |
| 8 | 1244 | 2.9% |
| 7 | 1043 | 2.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 36365 | |
| Other Punctuation | 7273 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 16404 | |
| 2 | 10689 | |
| 1 | 5415 | 14.9% |
| 9 | 1570 | 4.3% |
| 8 | 1244 | 3.4% |
| 7 | 1043 | 2.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 7273 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 43638 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 16404 | |
| 2 | 10689 | |
| . | 7273 | |
| 1 | 5415 | 12.4% |
| 9 | 1570 | 3.6% |
| 8 | 1244 | 2.9% |
| 7 | 1043 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43638 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 16404 | |
| 2 | 10689 | |
| . | 7273 | |
| 1 | 5415 | 12.4% |
| 9 | 1570 | 3.6% |
| 8 | 1244 | 2.9% |
| 7 | 1043 | 2.4% |
ESG Score
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIQUE| Distinct | 7273 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.5951191 |
| Minimum | 5.114833664 |
|---|---|
| Maximum | 94.44445553 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | 5.114833664 |
|---|---|
| 5-th percentile | 16.99017483 |
| Q1 | 31.08531755 |
| median | 43.89661443 |
| Q3 | 59.68062035 |
| 95-th percentile | 78.64482082 |
| Maximum | 94.44445553 |
| Range | 89.32962187 |
| Interquartile range (IQR) | 28.5953028 |
Descriptive statistics
| Standard deviation | 18.86600105 |
|---|---|
| Coefficient of variation (CV) | 0.4137723823 |
| Kurtosis | -0.728016009 |
| Mean | 45.5951191 |
| Median Absolute Deviation (MAD) | 14.05217136 |
| Skewness | 0.2459283091 |
| Sum | 331613.3012 |
| Variance | 355.9259955 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 27.08101803 | 1 | < 0.1% |
| 39.77067073 | 1 | < 0.1% |
| 26.86161918 | 1 | < 0.1% |
| 28.01631135 | 1 | < 0.1% |
| 32.78846509 | 1 | < 0.1% |
| 30.88813499 | 1 | < 0.1% |
| 69.34418123 | 1 | < 0.1% |
| 61.58598124 | 1 | < 0.1% |
| 68.48282461 | 1 | < 0.1% |
| 49.97841456 | 1 | < 0.1% |
| Other values (7263) | 7263 |
| Value | Count | Frequency (%) |
| 5.114833664 | 1 | |
| 5.776484991 | 1 | |
| 5.974997495 | 1 | |
| 6.152221193 | 1 | |
| 6.221658567 | 1 | |
| 6.686398355 | 1 | |
| 6.81418215 | 1 | |
| 6.868101403 | 1 | |
| 6.966379589 | 1 | |
| 7.221805913 | 1 |
| Value | Count | Frequency (%) |
| 94.44445553 | 1 | |
| 93.53912565 | 1 | |
| 93.32784124 | 1 | |
| 92.80650836 | 1 | |
| 92.61992314 | 1 | |
| 92.31516263 | 1 | |
| 92.1429952 | 1 | |
| 91.90508406 | 1 | |
| 91.85503349 | 1 | |
| 91.47686123 | 1 |
Environmental Pillar Score
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 6362 |
|---|---|
| Distinct (%) | 87.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.68848524 |
| Minimum | 0.027777778 |
|---|---|
| Maximum | 97.98022505 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | 0.027777778 |
|---|---|
| 5-th percentile | 1.771771772 |
| Q1 | 8.796296296 |
| median | 25.95088648 |
| Q3 | 53.125 |
| 95-th percentile | 81.67524908 |
| Maximum | 97.98022505 |
| Range | 97.95244727 |
| Interquartile range (IQR) | 44.3287037 |
Descriptive statistics
| Standard deviation | 26.34713048 |
|---|---|
| Coefficient of variation (CV) | 0.8060064664 |
| Kurtosis | -0.8601953105 |
| Mean | 32.68848524 |
| Median Absolute Deviation (MAD) | 19.68115939 |
| Skewness | 0.5904826047 |
| Sum | 237743.3532 |
| Variance | 694.1712847 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.740581784 | 52 | 0.7% |
| 1.771771772 | 39 | 0.5% |
| 1.608821403 | 33 | 0.5% |
| 4.945054945 | 18 | 0.2% |
| 37.31707317 | 18 | 0.2% |
| 1.924818841 | 16 | 0.2% |
| 6.302521008 | 16 | 0.2% |
| 3.460972018 | 14 | 0.2% |
| 3.236944325 | 14 | 0.2% |
| 3 | 13 | 0.2% |
| Other values (6352) | 7040 |
| Value | Count | Frequency (%) |
| 0.027777778 | 1 | |
| 0.086956522 | 1 | |
| 0.088593577 | 1 | |
| 0.142450142 | 1 | |
| 0.146297126 | 1 | |
| 0.194444444 | 1 | |
| 0.217013889 | 1 | |
| 0.255558395 | 1 | |
| 0.294612795 | 1 | |
| 0.308641975 | 1 |
| Value | Count | Frequency (%) |
| 97.98022505 | 1 | |
| 97.69705095 | 1 | |
| 97.16815059 | 1 | |
| 97.16090883 | 1 | |
| 97.02299593 | 1 | |
| 96.67922137 | 1 | |
| 96.62206002 | 1 | |
| 96.54273654 | 1 | |
| 96.3344614 | 1 | |
| 96.07514881 | 1 |
Social Pillar Score
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 7242 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.40329011 |
| Minimum | 0.453490413 |
|---|---|
| Maximum | 97.83313378 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | 0.453490413 |
|---|---|
| 5-th percentile | 15.33759499 |
| Q1 | 30.70256215 |
| median | 45.91989914 |
| Q3 | 63.01730829 |
| 95-th percentile | 84.72395018 |
| Maximum | 97.83313378 |
| Range | 97.37964337 |
| Interquartile range (IQR) | 32.31474614 |
Descriptive statistics
| Standard deviation | 21.21297296 |
|---|---|
| Coefficient of variation (CV) | 0.4475000134 |
| Kurtosis | -0.7505785007 |
| Mean | 47.40329011 |
| Median Absolute Deviation (MAD) | 16.05144928 |
| Skewness | 0.2364710717 |
| Sum | 344764.129 |
| Variance | 449.9902217 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 28.95333105 | 4 | 0.1% |
| 28.96555825 | 3 | < 0.1% |
| 50 | 3 | < 0.1% |
| 23.84305671 | 3 | < 0.1% |
| 22.47251138 | 3 | < 0.1% |
| 31.06869795 | 3 | < 0.1% |
| 25.1054216 | 3 | < 0.1% |
| 25.91686339 | 3 | < 0.1% |
| 37.5 | 2 | < 0.1% |
| 29.70593586 | 2 | < 0.1% |
| Other values (7232) | 7244 |
| Value | Count | Frequency (%) |
| 0.453490413 | 1 | |
| 1.250985028 | 1 | |
| 1.374185668 | 1 | |
| 2.058498218 | 1 | |
| 2.260348584 | 1 | |
| 2.440956221 | 1 | |
| 2.704071629 | 1 | |
| 2.708743072 | 1 | |
| 2.862323994 | 1 | |
| 2.868357488 | 1 |
| Value | Count | Frequency (%) |
| 97.83313378 | 1 | |
| 97.66874295 | 1 | |
| 97.65506268 | 1 | |
| 97.57901244 | 1 | |
| 97.39413182 | 1 | |
| 97.39293525 | 1 | |
| 97.34833138 | 1 | |
| 97.25672305 | 1 | |
| 97.23474375 | 1 | |
| 97.15683466 | 1 |
| Distinct | 7246 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53.30286473 |
| Minimum | 0.713528414 |
|---|---|
| Maximum | 99.49668624 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | 0.713528414 |
|---|---|
| 5-th percentile | 16.39364647 |
| Q1 | 36.92061081 |
| median | 54.97081144 |
| Q3 | 70.36096517 |
| 95-th percentile | 85.49530137 |
| Maximum | 99.49668624 |
| Range | 98.78315783 |
| Interquartile range (IQR) | 33.44035436 |
Descriptive statistics
| Standard deviation | 21.48435869 |
|---|---|
| Coefficient of variation (CV) | 0.4030619892 |
| Kurtosis | -0.8086517305 |
| Mean | 53.30286473 |
| Median Absolute Deviation (MAD) | 16.55039119 |
| Skewness | -0.2177612235 |
| Sum | 387671.7352 |
| Variance | 461.5776683 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 70.223046 | 2 | < 0.1% |
| 51.31558514 | 2 | < 0.1% |
| 60.88635921 | 2 | < 0.1% |
| 25.72314815 | 2 | < 0.1% |
| 24.66335863 | 2 | < 0.1% |
| 49.20694778 | 2 | < 0.1% |
| 35.74819745 | 2 | < 0.1% |
| 62.46257571 | 2 | < 0.1% |
| 50.8712963 | 2 | < 0.1% |
| 57.42315164 | 2 | < 0.1% |
| Other values (7236) | 7253 |
| Value | Count | Frequency (%) |
| 0.713528414 | 1 | |
| 1.21894023 | 1 | |
| 1.449805879 | 1 | |
| 1.621528968 | 1 | |
| 1.741942324 | 1 | |
| 1.77374894 | 1 | |
| 2.073211314 | 1 | |
| 2.223282443 | 1 | |
| 2.325063613 | 1 | |
| 2.462575706 | 1 |
| Value | Count | Frequency (%) |
| 99.49668624 | 1 | |
| 98.61065544 | 1 | |
| 98.1416741 | 1 | |
| 97.5232521 | 1 | |
| 97.49964879 | 1 | |
| 97.30143852 | 1 | |
| 97.02811555 | 1 | |
| 96.77316411 | 1 | |
| 96.67393058 | 1 | |
| 96.59345871 | 1 |
| Distinct | 7268 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.001136985144 |
| Minimum | -0.552090105 |
|---|---|
| Maximum | 0.5359062215 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 3186 |
| Negative (%) | 43.8% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | -0.552090105 |
|---|---|
| 5-th percentile | -0.07660494631 |
| Q1 | -0.01780396201 |
| median | 0.004320490956 |
| Q3 | 0.0235602911 |
| 95-th percentile | 0.06587996399 |
| Maximum | 0.5359062215 |
| Range | 1.087996327 |
| Interquartile range (IQR) | 0.04136425311 |
Descriptive statistics
| Standard deviation | 0.04781232323 |
|---|---|
| Coefficient of variation (CV) | 42.05184517 |
| Kurtosis | 13.28160525 |
| Mean | 0.001136985144 |
| Median Absolute Deviation (MAD) | 0.02032985182 |
| Skewness | -0.9680795522 |
| Sum | 8.269292952 |
| Variance | 0.002286018253 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.06301338005 | 2 | < 0.1% |
| 0.03146094461 | 2 | < 0.1% |
| 0.01152288233 | 2 | < 0.1% |
| 1.513940488 × 10-17 | 2 | < 0.1% |
| 0.039470474 | 2 | < 0.1% |
| -0.06947842107 | 1 | < 0.1% |
| -0.03050099186 | 1 | < 0.1% |
| 0.02415999341 | 1 | < 0.1% |
| 0.06235786844 | 1 | < 0.1% |
| 0.03056317333 | 1 | < 0.1% |
| Other values (7258) | 7258 |
| Value | Count | Frequency (%) |
| -0.552090105 | 1 | |
| -0.5304138823 | 1 | |
| -0.4925745599 | 1 | |
| -0.3896555938 | 1 | |
| -0.3346418915 | 1 | |
| -0.3307936064 | 1 | |
| -0.31315733 | 1 | |
| -0.2974380222 | 1 | |
| -0.2889139846 | 1 | |
| -0.2830468463 | 1 |
| Value | Count | Frequency (%) |
| 0.5359062215 | 1 | |
| 0.2835265788 | 1 | |
| 0.2558097662 | 1 | |
| 0.2494473479 | 1 | |
| 0.2376677679 | 1 | |
| 0.2321204633 | 1 | |
| 0.2282888654 | 1 | |
| 0.2206205853 | 1 | |
| 0.2199829472 | 1 | |
| 0.2096748972 | 1 |
semi-variance (down)
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDUNIQUE| Distinct | 7273 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03301529356 |
| Minimum | 2.049697647 × 10-6 |
|---|---|
| Maximum | 10.60379622 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | 2.049697647 × 10-6 |
|---|---|
| 5-th percentile | 0.001243005579 |
| Q1 | 0.004228974024 |
| median | 0.01011033186 |
| Q3 | 0.02653212721 |
| 95-th percentile | 0.1172569894 |
| Maximum | 10.60379622 |
| Range | 10.60379417 |
| Interquartile range (IQR) | 0.02230315318 |
Descriptive statistics
| Standard deviation | 0.1617104052 |
|---|---|
| Coefficient of variation (CV) | 4.898045353 |
| Kurtosis | 2617.090121 |
| Mean | 0.03301529356 |
| Median Absolute Deviation (MAD) | 0.007417430372 |
| Skewness | 43.67768601 |
| Sum | 240.1202301 |
| Variance | 0.02615025515 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.004021172732 | 1 | < 0.1% |
| 0.02582947016 | 1 | < 0.1% |
| 0.02049380886 | 1 | < 0.1% |
| 0.004465421519 | 1 | < 0.1% |
| 0.01445946784 | 1 | < 0.1% |
| 0.01063644202 | 1 | < 0.1% |
| 0.00529236128 | 1 | < 0.1% |
| 0.02166309697 | 1 | < 0.1% |
| 0.02236395096 | 1 | < 0.1% |
| 0.01191045911 | 1 | < 0.1% |
| Other values (7263) | 7263 |
| Value | Count | Frequency (%) |
| 2.049697647 × 10-6 | 1 | |
| 5.055098442 × 10-6 | 1 | |
| 5.08445488 × 10-6 | 1 | |
| 5.274323069 × 10-6 | 1 | |
| 6.131105551 × 10-6 | 1 | |
| 8.070466148 × 10-6 | 1 | |
| 1.132803218 × 10-5 | 1 | |
| 1.166024936 × 10-5 | 1 | |
| 1.237343283 × 10-5 | 1 | |
| 1.319121727 × 10-5 | 1 |
| Value | Count | Frequency (%) |
| 10.60379622 | 1 | |
| 4.401274089 | 1 | |
| 2.814765903 | 1 | |
| 2.660379866 | 1 | |
| 2.528239724 | 1 | |
| 1.683931968 | 1 | |
| 1.273938367 | 1 | |
| 1.182263803 | 1 | |
| 1.162310479 | 1 | |
| 1.129021699 | 1 |
| Distinct | 7273 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7105823339 |
| Minimum | -4.771690305 |
|---|---|
| Maximum | 10.66785002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 3172 |
| Negative (%) | 43.6% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | -4.771690305 |
|---|---|
| 5-th percentile | -1.375287965 |
| Q1 | -0.6194564829 |
| median | 0.2235622109 |
| Q3 | 1.512164106 |
| 95-th percentile | 4.510751604 |
| Maximum | 10.66785002 |
| Range | 15.43954032 |
| Interquartile range (IQR) | 2.131620589 |
Descriptive statistics
| Standard deviation | 1.865801242 |
|---|---|
| Coefficient of variation (CV) | 2.625735475 |
| Kurtosis | 2.221970281 |
| Mean | 0.7105823339 |
| Median Absolute Deviation (MAD) | 0.9802293374 |
| Skewness | 1.38930909 |
| Sum | 5168.065314 |
| Variance | 3.481214276 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -0.6328257409 | 1 | < 0.1% |
| 4.42868974 | 1 | < 0.1% |
| 2.783177392 | 1 | < 0.1% |
| 0.1109974028 | 1 | < 0.1% |
| -0.8031782944 | 1 | < 0.1% |
| 0.1201461924 | 1 | < 0.1% |
| -0.5098236926 | 1 | < 0.1% |
| 0.7872804591 | 1 | < 0.1% |
| -0.6079825612 | 1 | < 0.1% |
| 1.294556822 | 1 | < 0.1% |
| Other values (7263) | 7263 |
| Value | Count | Frequency (%) |
| -4.771690305 | 1 | |
| -3.303480138 | 1 | |
| -3.283662493 | 1 | |
| -3.010231764 | 1 | |
| -2.772284067 | 1 | |
| -2.768118263 | 1 | |
| -2.753330548 | 1 | |
| -2.719587297 | 1 | |
| -2.712449621 | 1 | |
| -2.669416528 | 1 |
| Value | Count | Frequency (%) |
| 10.66785002 | 1 | |
| 10.39619826 | 1 | |
| 10.39230482 | 1 | |
| 9.991123526 | 1 | |
| 9.330673785 | 1 | |
| 9.272796292 | 1 | |
| 9.136219555 | 1 | |
| 8.969254615 | 1 | |
| 8.909863957 | 1 | |
| 8.867227454 | 1 |
| Distinct | 7273 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.1679193383 |
| Minimum | -3.243905543 |
|---|---|
| Maximum | 3.118139779 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 4225 |
| Negative (%) | 58.1% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | -3.243905543 |
|---|---|
| 5-th percentile | -1.661676494 |
| Q1 | -0.7366655895 |
| median | -0.1743918841 |
| Q3 | 0.4104441429 |
| 95-th percentile | 1.322835232 |
| Maximum | 3.118139779 |
| Range | 6.362045322 |
| Interquartile range (IQR) | 1.147109732 |
Descriptive statistics
| Standard deviation | 0.8954242476 |
|---|---|
| Coefficient of variation (CV) | -5.332466507 |
| Kurtosis | 0.2061299936 |
| Mean | -0.1679193383 |
| Median Absolute Deviation (MAD) | 0.5719643003 |
| Skewness | 0.05438400105 |
| Sum | -1221.277348 |
| Variance | 0.8017845832 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.06114140649 | 1 | < 0.1% |
| -1.597617659 | 1 | < 0.1% |
| -0.9796808814 | 1 | < 0.1% |
| -0.6968493832 | 1 | < 0.1% |
| -0.3655078602 | 1 | < 0.1% |
| -0.6439972632 | 1 | < 0.1% |
| 0.9276741452 | 1 | < 0.1% |
| -0.728848908 | 1 | < 0.1% |
| -0.1534623855 | 1 | < 0.1% |
| 0.6952662407 | 1 | < 0.1% |
| Other values (7263) | 7263 |
| Value | Count | Frequency (%) |
| -3.243905543 | 1 | |
| -3.192624611 | 1 | |
| -3.192145101 | 1 | |
| -2.95715309 | 1 | |
| -2.91591035 | 1 | |
| -2.8410198 | 1 | |
| -2.816467798 | 1 | |
| -2.803226022 | 1 | |
| -2.794186419 | 1 | |
| -2.792800808 | 1 |
| Value | Count | Frequency (%) |
| 3.118139779 | 1 | |
| 2.939550184 | 1 | |
| 2.900624226 | 1 | |
| 2.846950478 | 1 | |
| 2.815081958 | 1 | |
| 2.781616199 | 1 | |
| 2.727624363 | 1 | |
| 2.674059504 | 1 | |
| 2.579003458 | 1 | |
| 2.575233083 | 1 |
| Distinct | 7271 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.1812995785 |
| Minimum | -5.756462732 |
|---|---|
| Maximum | 0.05449763172 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 7254 |
| Negative (%) | 99.7% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | -5.756462732 |
|---|---|
| 5-th percentile | -0.4711901745 |
| Q1 | -0.2285139713 |
| median | -0.1372989011 |
| Q3 | -0.07893893959 |
| 95-th percentile | -0.03226260506 |
| Maximum | 0.05449763172 |
| Range | 5.810960364 |
| Interquartile range (IQR) | 0.1495750318 |
Descriptive statistics
| Standard deviation | 0.174921993 |
|---|---|
| Coefficient of variation (CV) | -0.9648229435 |
| Kurtosis | 166.4759273 |
| Mean | -0.1812995785 |
| Median Absolute Deviation (MAD) | 0.06885300129 |
| Skewness | -7.360293362 |
| Sum | -1318.591834 |
| Variance | 0.03059770363 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -0.2653141255 | 2 | < 0.1% |
| -0.3465735903 | 2 | < 0.1% |
| -0.07107546858 | 1 | < 0.1% |
| -0.1767649292 | 1 | < 0.1% |
| -0.2231626123 | 1 | < 0.1% |
| -0.1451577862 | 1 | < 0.1% |
| -0.03603184996 | 1 | < 0.1% |
| -0.184144144 | 1 | < 0.1% |
| -0.1483465567 | 1 | < 0.1% |
| -0.1338984816 | 1 | < 0.1% |
| Other values (7261) | 7261 |
| Value | Count | Frequency (%) |
| -5.756462732 | 1 | |
| -3.453877639 | 1 | |
| -1.669998066 | 1 | |
| -1.64456756 | 1 | |
| -1.627902163 | 1 | |
| -1.609437912 | 1 | |
| -1.565283421 | 1 | |
| -1.530645946 | 1 | |
| -1.466440804 | 1 | |
| -1.440248505 | 1 |
| Value | Count | Frequency (%) |
| 0.05449763172 | 1 | |
| 0.05115661859 | 1 | |
| 0.03287686949 | 1 | |
| 0.02703480588 | 1 | |
| 0.01351776512 | 1 | |
| 0.01006396599 | 1 | |
| 0.005793158139 | 1 | |
| 0.004990776787 | 1 | |
| 0.004271896986 | 1 | |
| 0.003945673828 | 1 |
| Distinct | 2937 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 4336 |
| Missing (%) | 59.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.709579019 |
| Minimum | 6.79050927 × 10-8 |
|---|---|
| Maximum | 50.90867194 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | 6.79050927 × 10-8 |
|---|---|
| 5-th percentile | 0.006824963715 |
| Q1 | 0.1760470753 |
| median | 0.8848366336 |
| Q3 | 3.066449194 |
| 95-th percentile | 12.4814052 |
| Maximum | 50.90867194 |
| Range | 50.90867188 |
| Interquartile range (IQR) | 2.890402118 |
Descriptive statistics
| Standard deviation | 4.706685144 |
|---|---|
| Coefficient of variation (CV) | 1.737054026 |
| Kurtosis | 18.45084039 |
| Mean | 2.709579019 |
| Median Absolute Deviation (MAD) | 0.8400479742 |
| Skewness | 3.586007949 |
| Sum | 7958.033579 |
| Variance | 22.15288504 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.078563637 | 1 | < 0.1% |
| 5.80838985 | 1 | < 0.1% |
| 0.3522265929 | 1 | < 0.1% |
| 0.7981645858 | 1 | < 0.1% |
| 1.881086605 | 1 | < 0.1% |
| 4.724963344 | 1 | < 0.1% |
| 0.6789694413 | 1 | < 0.1% |
| 0.3202701144 | 1 | < 0.1% |
| 28.38155065 | 1 | < 0.1% |
| 0.5218527093 | 1 | < 0.1% |
| Other values (2927) | 2927 | |
| (Missing) | 4336 |
| Value | Count | Frequency (%) |
| 6.79050927 × 10-8 | 1 | |
| 2.920950538 × 10-6 | 1 | |
| 4.884088178 × 10-6 | 1 | |
| 4.986095251 × 10-6 | 1 | |
| 6.958513263 × 10-6 | 1 | |
| 1.848653528 × 10-5 | 1 | |
| 1.863846349 × 10-5 | 1 | |
| 2.626211387 × 10-5 | 1 | |
| 2.637262071 × 10-5 | 1 | |
| 2.793033647 × 10-5 | 1 |
| Value | Count | Frequency (%) |
| 50.90867194 | 1 | |
| 45.29543076 | 1 | |
| 44.08411424 | 1 | |
| 40.11182434 | 1 | |
| 39.94788633 | 1 | |
| 38.52865772 | 1 | |
| 33.78034711 | 1 | |
| 33.49636273 | 1 | |
| 32.23911963 | 1 | |
| 31.06671918 | 1 |
| Distinct | 5942 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1331 |
| Missing (%) | 18.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.033419998 |
| Minimum | 7.201370445 × 10-8 |
|---|---|
| Maximum | 47.28022229 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 56.9 KiB |
Quantile statistics
| Minimum | 7.201370445 × 10-8 |
|---|---|
| 5-th percentile | 0.003865694903 |
| Q1 | 0.09087302745 |
| median | 0.3933587679 |
| Q3 | 1.166821518 |
| 95-th percentile | 3.91738911 |
| Maximum | 47.28022229 |
| Range | 47.28022221 |
| Interquartile range (IQR) | 1.07594849 |
Descriptive statistics
| Standard deviation | 2.110622726 |
|---|---|
| Coefficient of variation (CV) | 2.04236683 |
| Kurtosis | 125.297544 |
| Mean | 1.033419998 |
| Median Absolute Deviation (MAD) | 0.3625595722 |
| Skewness | 8.423620273 |
| Sum | 6140.581629 |
| Variance | 4.454728292 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.305471268 | 1 | < 0.1% |
| 0.7236987708 | 1 | < 0.1% |
| 1.812275196 | 1 | < 0.1% |
| 0.7336866453 | 1 | < 0.1% |
| 1.219104989 | 1 | < 0.1% |
| 0.2087770395 | 1 | < 0.1% |
| 2.484205142 | 1 | < 0.1% |
| 0.848846879 | 1 | < 0.1% |
| 0.007135806447 | 1 | < 0.1% |
| 0.1170365531 | 1 | < 0.1% |
| Other values (5932) | 5932 | |
| (Missing) | 1331 | 18.3% |
| Value | Count | Frequency (%) |
| 7.201370445 × 10-8 | 1 | |
| 1.615828905 × 10-7 | 1 | |
| 3.591858258 × 10-7 | 1 | |
| 5.596244496 × 10-7 | 1 | |
| 7.547698111 × 10-7 | 1 | |
| 9.188274723 × 10-7 | 1 | |
| 1.053538485 × 10-6 | 1 | |
| 1.207528765 × 10-6 | 1 | |
| 2.423971339 × 10-6 | 1 | |
| 2.98789117 × 10-6 | 1 |
| Value | Count | Frequency (%) |
| 47.28022229 | 1 | |
| 47.01104047 | 1 | |
| 37.17419917 | 1 | |
| 35.04497396 | 1 | |
| 28.14140719 | 1 | |
| 25.85330839 | 1 | |
| 22.90563473 | 1 | |
| 22.43001765 | 1 | |
| 20.23889516 | 1 | |
| 19.80086464 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Symbol | Year | ESG Score | Environmental Pillar Score | Social Pillar Score | Governance Pillar Score | mean-return | semi-variance (down) | kurtosis | skew | VaR (95%) | D(ESG, kurtosis) | D(ESG, VaR) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 360.AX | 2020.0 | 27.081018 | 8.916667 | 43.015144 | 18.809271 | 0.032846 | 0.004021 | -0.632826 | 0.061141 | -0.071075 | NaN | NaN |
| 1 | 360.AX | 2021.0 | 31.410958 | 8.453608 | 45.972210 | 25.759307 | 0.025825 | 0.005839 | 1.742724 | -0.646043 | -0.075298 | NaN | 0.008210 |
| 2 | A.N | 2017.0 | 87.595065 | 77.060658 | 92.792375 | 85.667996 | 0.035512 | 0.007012 | 0.455790 | 0.720648 | -0.096525 | NaN | NaN |
| 3 | A.N | 2018.0 | 89.489253 | 78.045737 | 94.201817 | 88.624684 | -0.061043 | 0.004451 | 0.610308 | 0.850044 | -0.162627 | 0.073191 | 0.250266 |
| 4 | A.N | 2019.0 | 88.330855 | 79.335997 | 94.505273 | 84.398806 | -0.029269 | 0.016082 | 0.126243 | -0.828252 | -0.228490 | 2.442125 | 0.124653 |
| 5 | A.N | 2020.0 | 87.577489 | 79.958977 | 93.599370 | 83.203984 | 0.045653 | 0.270980 | 4.900414 | -1.988309 | -0.520227 | 13.450079 | 0.691122 |
| 6 | AA.N | 2017.0 | 87.273109 | 90.333748 | 79.472149 | 95.671099 | -0.021786 | 0.002320 | 0.566293 | -0.682118 | -0.081101 | 7.558767 | 0.060957 |
| 7 | AA.N | 2018.0 | 86.619978 | 88.383537 | 79.128995 | 96.369097 | -0.033796 | 0.006287 | -0.703649 | -0.791101 | -0.137931 | NaN | 0.290054 |
| 8 | AA.N | 2019.0 | 88.078825 | 87.347163 | 83.474247 | 96.673931 | -0.039699 | 0.015111 | 2.266191 | -1.274915 | -0.223285 | NaN | 0.216216 |
| 9 | AA.N | 2020.0 | 87.753771 | 86.773289 | 83.217569 | 96.593459 | -0.037021 | 0.215737 | 5.702735 | -2.142136 | -0.557165 | 0.858482 | 0.842930 |
Last rows
| Symbol | Year | ESG Score | Environmental Pillar Score | Social Pillar Score | Governance Pillar Score | mean-return | semi-variance (down) | kurtosis | skew | VaR (95%) | D(ESG, kurtosis) | D(ESG, VaR) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7263 | ZUMZ.OQ | 2019.0 | 26.031559 | 5.594406 | 30.467751 | 31.321035 | -0.037472 | 0.049756 | 3.683881 | -1.761135 | -0.314004 | NaN | 0.903151 |
| 7264 | ZUMZ.OQ | 2020.0 | 25.939660 | 4.883721 | 30.834082 | 31.029383 | -0.005200 | 0.067349 | 0.572611 | -0.974624 | -0.385442 | 3.452085 | 0.043482 |
| 7265 | ZUMZ.OQ | 2021.0 | 24.257056 | 4.949495 | 27.183475 | 30.659259 | 0.021474 | 0.003797 | 3.069099 | 1.620179 | -0.078603 | 3.048510 | 2.319293 |
| 7266 | ZUO.N | 2020.0 | 36.287529 | 3.083333 | 54.970658 | 30.160537 | 0.017291 | 0.018535 | 1.256732 | -0.901465 | -0.182401 | NaN | NaN |
| 7267 | ZUO.N | 2021.0 | 53.918785 | 27.848701 | 66.407377 | 50.985744 | 0.062855 | 0.002580 | -0.551396 | 0.410789 | -0.016845 | NaN | 7.718136 |
| 7268 | ZWS.N | 2017.0 | 21.756603 | 4.250060 | 27.085541 | 35.777625 | -0.029082 | 0.107002 | 2.814027 | -1.311767 | -0.491496 | NaN | 0.894813 |
| 7269 | ZWS.N | 2018.0 | 22.966453 | 4.193398 | 24.531598 | 43.442041 | -0.127620 | 0.074135 | -1.053860 | -0.274952 | -0.461663 | NaN | 0.013628 |
| 7270 | ZWS.N | 2019.0 | 42.385059 | 47.923594 | 36.354082 | 43.646098 | 0.012917 | 0.035442 | 6.009275 | 2.079474 | -0.296457 | NaN | 1.114489 |
| 7271 | ZWS.N | 2020.0 | 59.566298 | 53.797153 | 76.736643 | 43.977042 | -0.038499 | 0.057422 | -0.321493 | -0.129591 | -0.393005 | NaN | 0.003407 |
| 7272 | ZWS.N | 2021.0 | 59.809391 | 70.174636 | 76.569419 | 25.396839 | -0.017465 | 0.010518 | 0.371196 | 1.074856 | -0.182711 | NaN | 0.592885 |